import openpyxl
myBook=openpyxl.load_workbook('员工表.xlsx',data_only=True)
mySheet=myBook.active

myRows=list(mySheet.values)[1:]
while mySheet.max_row>1:
	mySheet.delete_rows(2)

myList=[]
for myRow in myRows:
	if myRow not in myList:
		myList.append(myRow)

for myRow in myList:
	mySheet.append(myRow)

myBook.save('收入表.xlsx')